package com.gistone.commis.mapper;
import com.gistone.commis.entity.House;
import com.gistone.commis.query.QueryHouse;
import org.apache.ibatis.annotations.*;


import java.util.List;
@Mapper
public interface HouseMapper {




    @Select("SELECT * FROM tb_house_pro")
    List<House> findHouses();


    List<House> selectSelective(QueryHouse house);
    Double sumSelective(QueryHouse house);


    @Select("SELECT * FROM tb_house_pro WHERE house_id = #{houseId}")
    List<House> findHouseById(int houseId);

    @Delete(" delete from tb_house_pro"+
            "    where house_id = #{houseId,jdbcType=INTEGER}")



    int deleteByPrimaryKey(Integer houseId);

    int insert(House record);

    int insertSelective(House record);

    House selectByPrimaryKey(Integer houseId);

    int updateByPrimaryKey(House house);

    int updateByPrimaryKeySelective(House record);
}